MySQL连接Navicat premium时报错:Authentication plugin 'caching_sha2_password' cannot be loaded:
解决办法:
打开terminal或者命令行1
2 mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
root为设置的用户名,可以自己更改
如果是远程连接, 需要把localhost换为对应IP
密码根据自己的情况填写.
参考:
https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
解决办法:
ALTER USER ‘username‘@’ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’;
